#!/usr/bin/env python
#
# Copyright 2007 Google Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

import cgi
import wsgiref.handlers
import os
from google.appengine.api import users
from google.appengine.ext.webapp import template
from google.appengine.ext import webapp
from google.appengine.ext import db
from google.appengine.ext.db import GqlQuery
from google.appengine.ext.webapp.util import run_wsgi_app

from db_weather import DbWeather
from general_db import GeneralDb
import gviz_api

class Movie(webapp.RequestHandler):

  def get(self):
    generaldb_query = GeneralDb.all().order('-date_input')
    template_values = {
      'generaldbs': generaldb_query,
    }
    description = {"date": "string",
               "title": "string"}
    data = [{"date":generaldb.date_input, "title":generaldb.content} for generaldb in generaldb_query]
    #data = [{"date": "Mike", "title": "full_time"},
    #    {"date": "Mik2", "title": "full_time2"}]
    data_table = gviz_api.DataTable(description)
    data_table.LoadData(data)
    #self.response.out.write("Content-type: text/plain\n")
    #print "123"
    #self.response.out.write("123")
    self.response.out.write(data_table.ToJSonResponse(columns_order=("date", "title"),
                                order_by="date"))